{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Vorlage Liquiditätsplanung"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vorlage Liquiditätsplanung","index":0,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,"Liquiditätsplanung"]
[]
[null,"Berücksichtigung der Personenanzahl",0,"Anzahl Erwachsene",null,"1 Person","2 Personen","1 Kind","2 Kinder"]
[null,null,0,"Anzahl Kinder",null,900,1300,350,700]
[{"$nulls":5},{"$f":"IF(C3=1,F4,IF(C3=2,G4,0))","v":0},null,{"$f":"IF(C4=1,H4,IF(C4=2,I4,0))","v":0},null,{"$f":"SUM(F5:I5)","v":0}]
[{"$nulls":5},"Miete"]
[null,"* Pauschale für Lebensmittel, Kleidung, Körperpflege, Telefon/Internet, GEZ, Freizeit, Kultur)",null,null,null,{"$f":"C16*35%","v":0}]
[]
[null,"Liquide Mittel pro Monat","EUR"]
[null,"Einkünfte (Rente, Gewerbe, Angestellter)",0]
[null,"Erträge aus Kapitalanlagen",0]
[null,"Einkünfte aus Nebengewerbe",0]
[null,"Einkünfte aus Immobilien",0]
[null,"Einkünfte durch Unterhalt",0]
[null,"Sonstige Einkünfte",0]
[null,"Summe Einzahlungen",{"$f":"SUM(C10:C15)","v":0}]
[]
[null,"Ausgaben pro Monat","EUR",{"$f":"IF(C19<=F7,\"\",\"Achtung, die avisierte Miete ist für Sie wahrscheinlich zu hoch!\")","v":""}]
[null,"Warmmiete lt. Inserat",0,{"$f":"IF(C19<=F7,\"\",\"Folgender Betrag ist der max. betrag für die Warmmiete:\")","v":""},null,null,{"$f":"IF(C19<=F7,\"\",F7)","v":""}]
[null,"Lebenshaltungskosten*",{"$f":"J5","v":0}]
[null,"Kredit-/Leasingraten",0]
[null,"KFZ-/Transportkosten",0]
[null,"Versicherungen",0]
[null,"Kinderkosten (Kita, Schule, TG, etc.)",0]
[null,"Sonstiges"]
[null,"Summe Auszahlungen",{"$f":"SUM(C19:C25)","v":0}]
[]
[null,"Über-/ Unterdeckung pro Monat",{"$f":"C16-C26","v":0}]